package com.example.zhongcao.mapper;
import com.example.zhongcao.entity.UserSign;
import org.apache.ibatis.annotations.*;

import java.util.List;


@Mapper
public interface UserSignMapper {
    @Select("select * from user_sign where openid=#{openid} and signname=#{signname}")
    UserSign selectByOpenidAndName(String openid,String signname);

    @Insert("insert into user_sign(openid,signname) values(#{openid},#{signname})")
    void insertUserSign(String openid,String signname);

    @Select("select signname from user_sign where openid=#{openid}")
    List<String> selectNamesByOpenid(String openid);

    @Select("select signname from zhongcao_sign where zhongcaoid=#{zhongcaoid}")
    List<String> selectNamesByZhongcaoid(Integer zhongcaoid);
}
